<?php
/***************************************************************************
 *                              admin_styles.php
 *                            -------------------
 *   begin                : Thursday, Jul 12, 2001
 *   copyright            : (C) 2001 The phpBB Group
 *   email                : support@phpbb.com
 *
 *   $Id: admin_styles.php,v 1.27.2.9 2002/12/21 19:09:57 psotfx Exp $
 *
 *
 ***************************************************************************/
/***************************************************************************
* phpbb2 forums port version 2.0.5 (c) 2003 - Nuke Cops (http://nukecops.com)
*
* Ported by Nuke Cops to phpbb2 standalone 2.0.5 Test
* and debugging completed by the Elite Nukers and site members.
*
* You run this package at your sole risk. Nuke Cops and affiliates cannot
* be held liable if anything goes wrong. You are advised to test this
* package on a development system. Backup everything before implementing
* in a production environment. If something goes wrong, you can always
* backout and restore your backups.
*
* Installing and running this also means you agree to the terms of the AUP
* found at Nuke Cops.
*
* This is version 2.0.5 of the phpbb2 forum port for PHP-Nuke. Work is based
* on Tom Nitzschner's forum port version 2.0.6. Tom's 2.0.6 port was based
* on the phpbb2 standalone version 2.0.3. Our version 2.0.5 from Nuke Cops is
* now reflecting phpbb2 standalone 2.0.5 that fixes some bugs and the
* invalid_session error message.
***************************************************************************/
/***************************************************************************
 *   This file is part of the phpBB2 port to Nuke 6.0 (c) copyright 2002
 *   by Tom Nitzschner (tom@toms-home.com)
 *   http://bbtonuke.sourceforge.net (or http://www.toms-home.com)
 *
 *   As always, make a backup before messing with anything. All code
 *   release by me is considered sample code only. It may be fully
 *   functual, but you use it at your own risk, if you break it,
 *   you get to fix it too. No waranty is given or implied.
 *
 *   Please post all questions/request about this port on http://bbtonuke.sourceforge.net first,
 *   then on my site. All original header code and copyright messages will be maintained
 *   to give credit where credit is due. If you modify this, the only requirement is
 *   that you also maintain all original copyright messages. All my work is released
 *   under the GNU GENERAL PUBLIC LICENSE. Please see the README for more information.
 *
 ***************************************************************************/
/***************************************************************************
 *
 *   This program is free software; you can redistribute it and/or modify
 *   it under the terms of the GNU General Public License as published by
 *   the Free Software Foundation; either version 2 of the License, or
 *   (at your option) any later version.
 *
 ***************************************************************************/

define('IN_PHPBB', 1);

if( !empty($setmodules) )
{
        $file = basename(__FILE__);
        $module['Styles']['Add_new'] = "$file?mode=addnew";
        $module['Styles']['Create_new'] = "$file?mode=create";
        $module['Styles']['Manage'] = "$file";
        $module['Styles']['Export'] = "$file?mode=export";
        return;
}

//
// Load default header
//
//
// Check if the user has cancled a confirmation message.
//
$phpbb_root_path = "./../";

require($phpbb_root_path . 'extension.inc');

$confirm = ( isset($HTTP_POST_VARS['confirm']) ) ? TRUE : FALSE;
$cancel = ( isset($HTTP_POST_VARS['cancel']) ) ? TRUE : FALSE;

$no_page_header = (!empty($HTTP_POST_VARS['send_file']) || $cancel) ? TRUE : FALSE;

require('./pagestart.' . $phpEx);

if ($cancel)
{
        $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', $_SERVER['SERVER_SOFTWARE']) ) ? 'Refresh: 0; URL=' : 'Location: ';
        header($header_location  . append_sid("admin_styles.$phpEx"));
        exit;
}

if( isset($HTTP_GET_VARS['mode']) || isset($HTTP_POST_VARS['mode']) )
{
        $mode = ( isset($HTTP_GET_VARS['mode']) ) ? $HTTP_GET_VARS['mode'] : $HTTP_POST_VARS['mode'];
}
else
{
        $mode = "";
}

switch( $mode )
{
        case "addnew":
                $install_to = ( isset($HTTP_GET_VARS['install_to']) ) ? urldecode($HTTP_GET_VARS['install_to']) : $HTTP_POST_VARS['install_to'];
                $style_name = ( isset($HTTP_GET_VARS['style']) ) ? urldecode($HTTP_GET_VARS['style']) : $HTTP_POST_VARS['style'];

                if( isset($install_to) )
                {

                        include($phpbb_root_path. "templates/" . $install_to . "/theme_info.cfg");

                        $template_name = $$install_to;
                        $found = FALSE;

                        for($i = 0; $i < count($template_name) && !$found; $i++)
                        {
                                if( $template_name[$i]['style_name'] == $style_name )
                                {
                                        while(list($key, $val) = each($template_name[$i]))
                                        {
                                                $db_fields[] = $key;
                                                $db_values[] = str_replace("\'", "''" , $val);
                                        }
                                }
                        }

                        $sql = "INSERT INTO " . THEMES_TABLE . " (";

                        for($i = 0; $i < count($db_fields); $i++)
                        {
                                $sql .= $db_fields[$i];
                                if($i != (count($db_fields) - 1))
                                {
                                        $sql .= ", ";
                                }

                        }

                        $sql .= ") VALUES (";

                        for($i = 0; $i < count($db_values); $i++)
                        {
                                $sql .= "'" . $db_values[$i] . "'";
                                if($i != (count($db_values) - 1))
                                {
                                        $sql .= ", ";
                                }
                        }
                        $sql .= ")";

                        if( !$result = $db->sql_query($sql) )
                        {
                                message_die(GENERAL_ERROR, "Could not insert theme data!", "", __LINE__, __FILE__, $sql);
                        }

                        $message = $lang['Theme_installed'] . "<br /><br />" . sprintf($lang['Click_return_styleadmin'], "<a href=\"" . append_sid("admin_styles.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

                        message_die(GENERAL_MESSAGE, $message);
                }
                else
                {

                        $installable_themes = array();

                        if( $dir = @opendir($phpbb_root_path. "templates/") )
                        {
                                while( $sub_dir = @readdir($dir) )
                                {
                                        if( !is_file(phpbb_realpath($phpbb_root_path . 'templates/' .$sub_dir)) && !is_link(phpbb_realpath($phpbb_root_path . 'templates/' .$sub_dir)) && $sub_dir != "." && $sub_dir != ".." && $sub_dir != "CVS" )
                                        {
                                                if( @file_exists(@phpbb_realpath($phpbb_root_path. "templates/" . $sub_dir . "/theme_info.cfg")) )
                                                {
                                                        include($phpbb_root_path. "templates/" . $sub_dir . "/theme_info.cfg");

                                                        for($i = 0; $i < count($$sub_dir); $i++)
                                                        {
                                                                $working_data = $$sub_dir;

                                                                $style_name = $working_data[$i]['style_name'];

                                                                $sql = "SELECT themes_id
                                                                        FROM " . THEMES_TABLE . "
                                                                        WHERE style_name = '" . str_replace("\'", "''", $style_name) . "'";
                                                                if(!$result = $db->sql_query($sql))
                                                                {
                                                                        message_die(GENERAL_ERROR, "Could not query themes table!", "", __LINE__, __FILE__, $sql);
                                                                }

                                                                if(!$db->sql_numrows($result))
                                                                {
                                                                        $installable_themes[] = $working_data[$i];
                                                                }
                                                        }
                                                }
                                        }
                                }

                                $template->set_filenames(array(
                                        "body" => "admin/styles_addnew_body.tpl")
                                );

                                $template->assign_vars(array(
                                        "L_STYLES_TITLE" => $lang['Styles_admin'],
                                        "L_STYLES_ADD_TEXT" => $lang['Styles_addnew_explain'],
                                        "L_STYLE" => $lang['Style'],
                                        "L_TEMPLATE" => $lang['Template'],
                                        "L_INSTALL" => $lang['Install'],
                                        "L_ACTION" => $lang['Action'])
                                );

                                for($i = 0; $i < count($installable_themes); $i++)
                                {
                                        $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
                                        $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

                                        $template->assign_block_vars("styles", array(
                                                "ROW_CLASS" => $row_class,
                                                "ROW_COLOR" => "#" . $row_color,
                                                "STYLE_NAME" => $installable_themes[$i]['style_name'],
                                                "TEMPLATE_NAME" => $installable_themes[$i]['template_name'],

                                                "U_STYLES_INSTALL" => append_sid("admin_styles.$phpEx?mode=addnew&amp;style=" . urlencode($installable_themes[$i]['style_name']) . "&amp;install_to=" . urlencode($installable_themes[$i]['template_name'])))
                                        );

                                }
                                $template->pparse("body");

                        }
                        closedir($dir);
                }
                break;

        case "create":
        case "edit":
                $submit = ( isset($HTTP_POST_VARS['submit']) ) ? TRUE : 0;

                if( $submit )
                {
                        //
                        // DAMN! Thats alot of data to validate...
                        //
                        $updated['style_name'] = $HTTP_POST_VARS['style_name'];
                        $updated['template_name'] = $HTTP_POST_VARS['template_name'];
                        $updated['head_stylesheet'] = $HTTP_POST_VARS['head_stylesheet'];
                        $updated['body_background'] = $HTTP_POST_VARS['body_background'];
                        $updated['body_bgcolor'] = $HTTP_POST_VARS['body_bgcolor'];
                        $updated['body_text'] = $HTTP_POST_VARS['body_text'];
                        $updated['body_link'] = $HTTP_POST_VARS['body_link'];
                        $updated['body_vlink'] = $HTTP_POST_VARS['body_vlink'];
                        $updated['body_alink'] = $HTTP_POST_VARS['body_alink'];
                        $updated['body_hlink'] = $HTTP_POST_VARS['body_hlink'];
                        $updated['tr_color1'] = $HTTP_POST_VARS['tr_color1'];
                        $updated_name['tr_color1_name'] =  $HTTP_POST_VARS['tr_color1_name'];
                        $updated['tr_color2'] = $HTTP_POST_VARS['tr_color2'];
                        $updated_name['tr_color2_name'] = $HTTP_POST_VARS['tr_color2_name'];
                        $updated['tr_color3'] = $HTTP_POST_VARS['tr_color3'];
                        $updated_name['tr_color3_name'] = $HTTP_POST_VARS['tr_color3_name'];
                        $updated['tr_class1'] = $HTTP_POST_VARS['tr_class1'];
                        $updated_name['tr_class1_name'] = $HTTP_POST_VARS['tr_class1_name'];
                        $updated['tr_class2'] = $HTTP_POST_VARS['tr_class2'];
                        $updated_name['tr_class2_name'] = $HTTP_POST_VARS['tr_class2_name'];
                        $updated['tr_class3'] = $HTTP_POST_VARS['tr_class3'];
                        $updated_name['tr_class3_name'] = $HTTP_POST_VARS['tr_class3_name'];
                        $updated['th_color1'] = $HTTP_POST_VARS['th_color1'];
                        $updated_name['th_color1_name'] = $HTTP_POST_VARS['th_color1_name'];
                        $updated['th_color2'] = $HTTP_POST_VARS['th_color2'];
                        $updated_name['th_color2_name'] = $HTTP_POST_VARS['th_color2_name'];
                        $updated['th_color3'] = $HTTP_POST_VARS['th_color3'];
                        $updated_name['th_color3_name'] = $HTTP_POST_VARS['th_color3_name'];
                        $updated['th_class1'] = $HTTP_POST_VARS['th_class1'];
                        $updated_name['th_class1_name'] = $HTTP_POST_VARS['th_class1_name'];
                        $updated['th_class2'] = $HTTP_POST_VARS['th_class2'];
                        $updated_name['th_class2_name'] = $HTTP_POST_VARS['th_class2_name'];
                        $updated['th_class3'] = $HTTP_POST_VARS['th_class3'];
                        $updated_name['th_class3_name'] = $HTTP_POST_VARS['th_class3_name'];
                        $updated['td_color1'] = $HTTP_POST_VARS['td_color1'];
                        $updated_name['td_color1_name'] = $HTTP_POST_VARS['td_color1_name'];
                        $updated['td_color2'] = $HTTP_POST_VARS['td_color2'];
                        $updated_name['td_color2_name'] = $HTTP_POST_VARS['td_color2_name'];
                        $updated['td_color3'] = $HTTP_POST_VARS['td_color3'];
                        $updated_name['td_color3_name'] = $HTTP_POST_VARS['td_color3_name'];
                        $updated['td_class1'] = $HTTP_POST_VARS['td_class1'];
                        $updated_name['td_class1_name'] = $HTTP_POST_VARS['td_class1_name'];
                        $updated['td_class2'] = $HTTP_POST_VARS['td_class2'];
                        $updated_name['td_class2_name'] = $HTTP_POST_VARS['td_class2_name'];
                        $updated['td_class3'] = $HTTP_POST_VARS['td_class3'];
                        $updated_name['td_class3_name'] = $HTTP_POST_VARS['td_class3_name'];
                        $updated['fontface1'] = $HTTP_POST_VARS['fontface1'];
                        $updated_name['fontface1_name'] = $HTTP_POST_VARS['fontface1_name'];
                        $updated['fontface2'] = $HTTP_POST_VARS['fontface2'];
                        $updated_name['fontface2_name'] = $HTTP_POST_VARS['fontface2_name'];
                        $updated['fontface3'] = $HTTP_POST_VARS['fontface3'];
                        $updated_name['fontface3_name'] = $HTTP_POST_VARS['fontface3_name'];
                        $updated['fontsize1'] = intval($HTTP_POST_VARS['fontsize1']);
                        $updated_name['fontsize1_name'] = $HTTP_POST_VARS['fontsize1_name'];
                        $updated['fontsize2'] = intval($HTTP_POST_VARS['fontsize2']);
                        $updated_name['fontsize2_name'] = $HTTP_POST_VARS['fontsize2_name'];
                        $updated['fontsize3'] = intval($HTTP_POST_VARS['fontsize3']);
                        $updated_name['fontsize3_name'] = $HTTP_POST_VARS['fontsize3_name'];
                        $updated['fontcolor1'] = $HTTP_POST_VARS['fontcolor1'];
                        $updated_name['fontcolor1_name'] = $HTTP_POST_VARS['fontcolor1_name'];
                        $updated['fontcolor2'] = $HTTP_POST_VARS['fontcolor2'];
                        $updated_name['fontcolor2_name'] = $HTTP_POST_VARS['fontcolor2_name'];
                        $updated['fontcolor3'] = $HTTP_POST_VARS['fontcolor3'];
                        $updated_name['fontcolor3_name'] = $HTTP_POST_VARS['fontcolor3_name'];
                        $updated['span_class1'] = $HTTP_POST_VARS['span_class1'];
                        $updated_name['span_class1_name'] = $HTTP_POST_VARS['span_class1_name'];
                        $updated['span_class2'] = $HTTP_POST_VARS['span_class2'];
                        $updated_name['span_class2_name'] = $HTTP_POST_VARS['span_class2_name'];
                        $updated['span_class3'] = $HTTP_POST_VARS['span_class3'];
                        $updated_name['span_class3_name'] = $HTTP_POST_VARS['span_class3_name'];
                        $style_id = intval($HTTP_POST_VARS['style_id']);
                        //
                        // Wheeeew! Thank heavens for copy and paste and search and replace :D
                        //

                        if($mode == "edit")
                        {
                                $sql = "UPDATE " . THEMES_TABLE . " SET ";
                                $count = 0;

                                while(list($key, $val) = each($updated))
                                {
                                        if($count != 0)
                                        {
                                                $sql .= ", ";
                                        }

                                        //
                                        // I don't like this but it'll keep MSSQL from throwing
                                        // an error and save me alot of typing
                                        //
                                        $sql .= ( stristr($key, "fontsize") ) ? "$key = $val" : "$key = '" . str_replace("\'", "''", $val) . "'";

                                        $count++;
                                }

                                $sql .= " WHERE themes_id = $style_id";

                                if(!$result = $db->sql_query($sql))
                                {
                                        message_die(GENERAL_ERROR, "Could not update themes table!", "", __LINE__, __FILE__, $sql);
                                }

                                //
                                // Check if there's a names table entry for this style
                                //
                                $sql = "SELECT themes_id
                                        FROM " . THEMES_NAME_TABLE . "
                                        WHERE themes_id = $style_id";
                                if(!$result = $db->sql_query($sql))
                                {
                                        message_die(GENERAL_ERROR, "Could not get data from themes_name table", "", __LINE__, __FILE__, $sql);
                                }

                                if($db->sql_numrows($result) > 0)
                                {
                                        $sql = "UPDATE " . THEMES_NAME_TABLE . "
                                                SET ";
                                        $count = 0;
                                        while(list($key, $val) = each($updated_name))
                                        {
                                                if($count != 0)
                                                {
                                                        $sql .= ", ";
                                                }

                                                $sql .= "$key = '$val'";

                                                $count++;
                                        }

                                        $sql .= " WHERE themes_id = $style_id";
                                }
                                else
                                {
                                        //
                                        // Nope, no names entry so we create a new one.
                                        //
                                        $sql = "INSERT INTO " . THEMES_NAME_TABLE . " (themes_id, ";
                                        while(list($key, $val) = each($updated_name))
                                        {
                                                $fields[] = $key;
                                                $vals[] = str_replace("\'", "''", $val);
                                        }

                                        for($i = 0; $i < count($fields); $i++)
                                        {
                                                if($i > 0)
                                                {
                                                        $sql .= ", ";
                                                }
                                                $sql .= $fields[$i];
                                        }

                                        $sql .= ") VALUES ($style_id, ";
                                        for($i = 0; $i < count($vals); $i++)
                                        {
                                                if($i > 0)
                                                {
                                                        $sql .= ", ";
                                                }
                                                $sql .= "'" . $vals[$i] . "'";
                                        }

                                        $sql .= ")";
                                }

                                if(!$result = $db->sql_query($sql))
                                {
                                        message_die(GENERAL_ERROR, "Could not update themes name table!", "", __LINE__, __FILE__, $sql);
                                }

                                $message = $lang['Theme_updated'] . "<br /><br />" . sprintf($lang['Click_return_styleadmin'], "<a href=\"" . append_sid("admin_styles.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

                                message_die(GENERAL_MESSAGE, $message);
                        }
                        else
                        {
                                //
                                // First, check if we already have a style by this name
                                //
                                $sql = "SELECT themes_id
                                        FROM " . THEMES_TABLE . "
                                        WHERE style_name = '" . str_replace("\'", "''", $updated['style_name']) . "'";
                                if(!$result = $db->sql_query($sql))
                                {
                                        message_die(GENERAL_ERROR, "Could not query themes table", "", __LINE__, __FILE__, $sql);
                                }

                                if($db->sql_numrows($result))
                                {
                                        message_die(GENERAL_ERROR, $lang['Style_exists'], $lang['Error']);
                                }

                                while(list($key, $val) = each($updated))
                                {
                                        $field_names[] = $key;

                                        if(stristr($key, "fontsize"))
                                        {
                                                $values[] = "$val";
                                        }
                                        else
                                        {
                                                $values[] = "'" . str_replace("\'", "''", $val) . "'";
                                        }
                                }

                                $sql = "INSERT
                                        INTO " . THEMES_TABLE . " (";
                                for($i = 0; $i < count($field_names); $i++)
                                {
                                        if($i != 0)
                                        {
                                                $sql .= ", ";
                                        }
                                        $sql .= $field_names[$i];
                                }

                                $sql .= ") VALUES (";
                                for($i = 0; $i < count($values); $i++)
                                {
                                        if($i != 0)
                                        {
                                                $sql .= ", ";
                                        }
                                        $sql .= $values[$i];
                                }
                                $sql .= ")";

                                if(!$result = $db->sql_query($sql))
                                {
                                        message_die(GENERAL_ERROR, "Could not update themes table!", "", __LINE__, __FILE__, $sql);
                                }

                                $style_id = $db->sql_nextid();

                                //
                                // Insert names data
                                //
                                $sql = "INSERT INTO " . THEMES_NAME_TABLE . " (themes_id, ";
                                while(list($key, $val) = each($updated_name))
                                {
                                        $fields[] = $key;
                                        $vals[] = $val;
                                }

                                for($i = 0; $i < count($fields); $i++)
                                {
                                        if($i > 0)
                                        {
                                                $sql .= ", ";
                                        }
                                        $sql .= $fields[$i];
                                }

                                $sql .= ") VALUES ($style_id, ";
                                for($i = 0; $i < count($vals); $i++)
                                {
                                        if($i > 0)
                                        {
                                        $sql .= ", ";
                                        }
                                $sql .= "'" . $vals[$i] . "'";
                                }

                                $sql .= ")";

                                if(!$result = $db->sql_query($sql))
                                {
                                        message_die(GENERAL_ERROR, "Could not insert themes name table!", "", __LINE__, __FILE__, $sql);
                                }

                                $message = $lang['Theme_created'] . "<br /><br />" . sprintf($lang['Click_return_styleadmin'], "<a href=\"" . append_sid("admin_styles.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

                                message_die(GENERAL_MESSAGE, $message);
                        }
                }
                else
                {
                        if($mode == "edit")
                        {
                                $themes_title = $lang['Edit_theme'];
                                $themes_explain = $lang['Edit_theme_explain'];

                                $style_id = $HTTP_GET_VARS['style_id'];

                                $selected_names = array();
                                $selected_values = array();
                                //
                                // Fetch the Theme Info from the db
                                //
                                $sql = "SELECT *
                                        FROM " . THEMES_TABLE . "
                                        WHERE themes_id = $style_id";
                                if(!$result = $db->sql_query($sql))
                                {
                                        message_die(GENERAL_ERROR, "Could not get data from themes table", "", __LINE__, __FILE__, $sql);
                                }

                                if ( $selected_values = $db->sql_fetchrow($result) )
                                {
                                        while(list($key, $val) = @each($selected_values))
                                        {
                                                $selected[$key] = $val;
                                        }
                                }

                                //
                                // Fetch the Themes Name data
                                //
                                $sql = "SELECT *
                                        FROM " . THEMES_NAME_TABLE . "
                                        WHERE themes_id = $style_id";
                                if(!$result = $db->sql_query($sql))
                                {
                                        message_die(GENERAL_ERROR, "Could not get data from themes name table", "", __LINE__, __FILE__, $sql);
                                }

                                if ( $selected_names = $db->sql_fetchrow($result) )
                                {
                                        while(list($key, $val) = @each($selected_names))
                                        {
                                                $selected[$key] = $val;
                                        }
                                }

                                $s_hidden_fields = '<input type="hidden" name="style_id" value="' . $style_id . '" />';
                        }
                        else
                        {
                                $themes_title = $lang['Create_theme'];
                                $themes_explain = $lang['Create_theme_explain'];
                        }

                        $template->set_filenames(array(
                                "body" => "admin/styles_edit_body.tpl")
                        );

                        if( $dir = @opendir($phpbb_root_path . 'templates/') )
                        {
                                $s_template_select = '<select name="template_name">';
                                while( $file = @readdir($dir) )
                                {
                                        if( !is_file(phpbb_realpath($phpbb_root_path . 'templates/' . $file)) && !is_link(phpbb_realpath($phpbb_root_path . 'templates/' . $file)) && $file != "." && $file != ".." && $file != "CVS" )
                                        {
                                                if($file == $selected['template_name'])
                                                {
                                                        $s_template_select .= '<option value="' . $file . '" selected="selected">' . $file . "</option>\n";
                                                }
                                                else
                                                {
                                                        $s_template_select .= '<option value="' . $file . '">' . $file . "</option>\n";
                                                }
                                        }
                                }
                                $s_template_select .= '</select>';
                        }
                        else
                        {
                                message_die(GENERAL_MESSAGE, $lang['No_template_dir']);
                        }

                        $s_hidden_fields .= '<input type="hidden" name="mode" value="' . $mode . '" />';

                        $template->assign_vars(array(
                                "L_THEMES_TITLE" => $themes_title,
                                "L_THEMES_EXPLAIN" => $themes_explain,
                                "L_THEME_NAME" => $lang['Theme_name'],
                                "L_TEMPLATE" => $lang['Template'],
                                "L_THEME_SETTINGS" => $lang['Theme_settings'],
                                "L_THEME_ELEMENT" => $lang['Theme_element'],
                                "L_SIMPLE_NAME" => $lang['Simple_name'],
                                "L_VALUE" => $lang['Value'],
                                "L_STYLESHEET" => $lang['Stylesheet'],
                                "L_BACKGROUND_IMAGE" => $lang['Background_image'],
                                "L_BACKGROUND_COLOR" => $lang['Background_color'],
                                "L_BODY_TEXT_COLOR" => $lang['Text_color'],
                                "L_BODY_LINK_COLOR" => $lang['Link_color'],
                                "L_BODY_VLINK_COLOR" => $lang['VLink_color'],
                                "L_BODY_ALINK_COLOR" => $lang['ALink_color'],
                                "L_BODY_HLINK_COLOR" => $lang['HLink_color'],
                                "L_TR_COLOR1" => $lang['Tr_color1'],
                                "L_TR_COLOR2" => $lang['Tr_color2'],
                                "L_TR_COLOR3" => $lang['Tr_color3'],
                                "L_TR_CLASS1" => $lang['Tr_class1'],
                                "L_TR_CLASS2" => $lang['Tr_class2'],
                                "L_TR_CLASS3" => $lang['Tr_class3'],
                                "L_TH_COLOR1" => $lang['Th_color1'],
                                "L_TH_COLOR2" => $lang['Th_color2'],
                                "L_TH_COLOR3" => $lang['Th_color3'],
                                "L_TH_CLASS1" => $lang['Th_class1'],
                                "L_TH_CLASS2" => $lang['Th_class2'],
                                "L_TH_CLASS3" => $lang['Th_class3'],
                                "L_TD_COLOR1" => $lang['Td_color1'],
                                "L_TD_COLOR2" => $lang['Td_color2'],
                                "L_TD_COLOR3" => $lang['Td_color3'],
                                "L_TD_CLASS1" => $lang['Td_class1'],
                                "L_TD_CLASS2" => $lang['Td_class2'],
                                "L_TD_CLASS3" => $lang['Td_class3'],
                                "L_FONTFACE_1" => $lang['fontface1'],
                                "L_FONTFACE_2" => $lang['fontface2'],
                                "L_FONTFACE_3" => $lang['fontface3'],
                                "L_FONTSIZE_1" => $lang['fontsize1'],
                                "L_FONTSIZE_2" => $lang['fontsize2'],
                                "L_FONTSIZE_3" => $lang['fontsize3'],
                                "L_FONTCOLOR_1" => $lang['fontcolor1'],
                                "L_FONTCOLOR_2" => $lang['fontcolor2'],
                                "L_FONTCOLOR_3" => $lang['fontcolor3'],
                                "L_SPAN_CLASS_1" => $lang['span_class1'],
                                "L_SPAN_CLASS_2" => $lang['span_class2'],
                                "L_SPAN_CLASS_3" => $lang['span_class3'],
                                "L_SAVE_SETTINGS" => $lang['Save_Settings'],
                                "THEME_NAME" => $selected['style_name'],
                                "HEAD_STYLESHEET" => $selected['head_stylesheet'],
                                "BODY_BACKGROUND" => $selected['body_background'],
                                "BODY_BGCOLOR" => $selected['body_bgcolor'],
                                "BODY_TEXT_COLOR" => $selected['body_text'],
                                "BODY_LINK_COLOR" => $selected['body_link'],
                                "BODY_VLINK_COLOR" => $selected['body_vlink'],
                                "BODY_ALINK_COLOR" => $selected['body_alink'],
                                "BODY_HLINK_COLOR" => $selected['body_hlink'],
                                "TR_COLOR1" => $selected['tr_color1'],
                                "TR_COLOR2" => $selected['tr_color2'],
                                "TR_COLOR3" => $selected['tr_color3'],
                                "TR_CLASS1" => $selected['tr_class1'],
                                "TR_CLASS2" => $selected['tr_class2'],
                                "TR_CLASS3" => $selected['tr_class3'],
                                "TH_COLOR1" => $selected['th_color1'],
                                "TH_COLOR2" => $selected['th_color2'],
                                "TH_COLOR3" => $selected['th_color3'],
                                "TH_CLASS1" => $selected['th_class1'],
                                "TH_CLASS2" => $selected['th_class2'],
                                "TH_CLASS3" => $selected['th_class3'],
                                "TD_COLOR1" => $selected['td_color1'],
                                "TD_COLOR2" => $selected['td_color2'],
                                "TD_COLOR3" => $selected['td_color3'],
                                "TD_CLASS1" => $selected['td_class1'],
                                "TD_CLASS2" => $selected['td_class2'],
                                "TD_CLASS3" => $selected['td_class3'],
                                "FONTFACE1" => $selected['fontface1'],
                                "FONTFACE2" => $selected['fontface2'],
                                "FONTFACE3" => $selected['fontface3'],
                                "FONTSIZE1" => $selected['fontsize1'],
                                "FONTSIZE2" => $selected['fontsize2'],
                                "FONTSIZE3" => $selected['fontsize3'],
                                "FONTCOLOR1" => $selected['fontcolor1'],
                                "FONTCOLOR2" => $selected['fontcolor2'],
                                "FONTCOLOR3" => $selected['fontcolor3'],
                                "SPAN_CLASS1" => $selected['span_class1'],
                                "SPAN_CLASS2" => $selected['span_class2'],
                                "SPAN_CLASS3" => $selected['span_class3'],

                                "TR_COLOR1_NAME" => $selected['tr_color1_name'],
                                "TR_COLOR2_NAME" => $selected['tr_color2_name'],
                                "TR_COLOR3_NAME" => $selected['tr_color3_name'],
                                "TR_CLASS1_NAME" => $selected['tr_class1_name'],
                                "TR_CLASS2_NAME" => $selected['tr_class2_name'],
                                "TR_CLASS3_NAME" => $selected['tr_class3_name'],
                                "TH_COLOR1_NAME" => $selected['th_color1_name'],
                                "TH_COLOR2_NAME" => $selected['th_color2_name'],
                                "TH_COLOR3_NAME" => $selected['th_color3_name'],
                                "TH_CLASS1_NAME" => $selected['th_class1_name'],
                                "TH_CLASS2_NAME" => $selected['th_class2_name'],
                                "TH_CLASS3_NAME" => $selected['th_class3_name'],
                                "TD_COLOR1_NAME" => $selected['td_color1_name'],
                                "TD_COLOR2_NAME" => $selected['td_color2_name'],
                                "TD_COLOR3_NAME" => $selected['td_color3_name'],
                                "TD_CLASS1_NAME" => $selected['td_class1_name'],
                                "TD_CLASS2_NAME" => $selected['td_class2_name'],
                                "TD_CLASS3_NAME" => $selected['td_class3_name'],
                                "FONTFACE1_NAME" => $selected['fontface1_name'],
                                "FONTFACE2_NAME" => $selected['fontface2_name'],
                                "FONTFACE3_NAME" => $selected['fontface3_name'],
                                "FONTSIZE1_NAME" => $selected['fontsize1_name'],
                                "FONTSIZE2_NAME" => $selected['fontsize2_name'],
                                "FONTSIZE3_NAME" => $selected['fontsize3_name'],
                                "FONTCOLOR1_NAME" => $selected['fontcolor1_name'],
                                "FONTCOLOR2_NAME" => $selected['fontcolor2_name'],
                                "FONTCOLOR3_NAME" => $selected['fontcolor3_name'],
                                "SPAN_CLASS1_NAME" => $selected['span_class1_name'],
                                "SPAN_CLASS2_NAME" => $selected['span_class2_name'],
                                "SPAN_CLASS3_NAME" => $selected['span_class3_name'],

                                "S_THEME_ACTION" => append_sid("admin_styles.$phpEx"),
                                "S_TEMPLATE_SELECT" => $s_template_select,
                                "S_HIDDEN_FIELDS" => $s_hidden_fields)
                        );

                        $template->pparse("body");
                }
                break;

        case "export";
                if($HTTP_POST_VARS['export_template'])
                {
                        $template_name = $HTTP_POST_VARS['export_template'];

                        $sql = "SELECT *
                                FROM " . THEMES_TABLE . "
                                WHERE template_name = '$template_name'";
                        if(!$result = $db->sql_query($sql))
                        {
                                message_die(GENERAL_ERROR, "Could not get theme data for selected template", "", __LINE__, __FILE__, $sql);
                        }

                        $theme_rowset = $db->sql_fetchrowset($result);

                        if( count($theme_rowset) == 0 )
                        {
                                message_die(GENERAL_MESSAGE, $lang['No_themes']);
                        }

                        $theme_data = '<?php'."\n\n";
                        $theme_data .= "//\n// phpBB 2.x auto-generated theme config file for $template_name\n// Do not change anything in this file!\n//\n\n";

                        for($i = 0; $i < count($theme_rowset); $i++)
                        {
                                while(list($key, $val) = each($theme_rowset[$i]))
                                {
                                        if(!intval($key) && $key != "0" && $key != "themes_id")
                                        {
                                                $theme_data .= '$' . $template_name . "[$i]['$key'] = \"" . addslashes($val) . "\";\n";
                                        }
                                }
                                $theme_data .= "\n";
                        }

                        $theme_data .= '?' . '>'; // Done this to prevent highlighting editors getting confused!

                        @umask(0111);

                        $fp = @fopen($phpbb_root_path . 'templates/' . $template_name . '/theme_info.cfg', 'w');

                        if( !$fp )
                        {
                                //
                                // Unable to open the file writeable do something here as an attempt
                                // to get around that...
                                //
                                $s_hidden_fields = '<input type="hidden" name="theme_info" value="' . htmlspecialchars($theme_data) . '" />';
                                $s_hidden_fields .= '<input type="hidden" name="send_file" value="1" /><input type="hidden" name="mode" value="export" />';

                                $download_form = '<form action="' . append_sid("admin_styles.$phpEx") . '" method="post"><input class="mainoption" type="submit" name="submit" value="' . $lang['Download'] . '" />' . $s_hidden_fields;

                                $template->set_filenames(array(
                                        "body" => "message_body.tpl")
                                );

                                $template->assign_vars(array(
                                        "MESSAGE_TITLE" => $lang['Export_themes'],
                                        "MESSAGE_TEXT" => $lang['Download_theme_cfg'] . "<br /><br />" . $download_form)
                                );

                                $template->pparse('body');
                                exit();
                        }

                        $result = @fputs($fp, $theme_data, strlen($theme_data));
                        fclose($fp);

                        $message = $lang['Theme_info_saved'] . "<br /><br />" . sprintf($lang['Click_return_styleadmin'], "<a href=\"" . append_sid("admin_styles.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

                        message_die(GENERAL_MESSAGE, $message);

                }
                else if($HTTP_POST_VARS['send_file'])
                {

                        header("Content-Type: text/x-delimtext; name=\"theme_info.cfg\"");
                        header("Content-disposition: attachment; filename=theme_info.cfg");

                        echo stripslashes($HTTP_POST_VARS['theme_info']);
                }
                else
                {
                        $template->set_filenames(array(
                                "body" => "admin/styles_exporter.tpl")
                        );

                        if( $dir = @opendir($phpbb_root_path . 'templates/') )
                        {
                                $s_template_select = '<select name="export_template">';
                                while( $file = @readdir($dir) )
                                {
                                        if( !is_file(phpbb_realpath($phpbb_root_path . 'templates/' . $file)) && !is_link(phpbb_realpath($phpbb_root_path . 'templates/' .$file)) && $file != "." && $file != ".." && $file != "CVS" )
                                        {
                                                $s_template_select .= '<option value="' . $file . '">' . $file . "</option>\n";
                                        }
                                }
                                $s_template_select .= '</select>';
                        }
                        else
                        {
                                message_die(GENERAL_MESSAGE, $lang['No_template_dir']);
                        }

                        $template->assign_vars(array(
                                "L_STYLE_EXPORTER" => $lang['Export_themes'],
                                "L_EXPORTER_EXPLAIN" => $lang['Export_explain'],
                                "L_TEMPLATE_SELECT" => $lang['Select_template'],
                                "L_SUBMIT" => $lang['Submit'],

                                "S_EXPORTER_ACTION" => append_sid("admin_styles.$phpEx?mode=export"),
                                "S_TEMPLATE_SELECT" => $s_template_select)
                        );

                        $template->pparse("body");

                }
                break;

        case "delete":
                $style_id = ( isset($HTTP_GET_VARS['style_id']) ) ? intval($HTTP_GET_VARS['style_id']) : intval($HTTP_POST_VARS['style_id']);

                if( !$confirm )
                {
                        if($style_id == $board_config['default_style'])
                        {
                                message_die(GENERAL_MESSAGE, $lang['Cannot_remove_style']);
                        }

                        $hidden_fields = '<input type="hidden" name="mode" value="'.$mode.'" /><input type="hidden" name="style_id" value="'.$style_id.'" />';

                        //
                        // Set template files
                        //
                        $template->set_filenames(array(
                                "confirm" => "confirm_body.tpl")
                        );

                        $template->assign_vars(array(
                                "MESSAGE_TITLE" => $lang['Confirm'],
                                "MESSAGE_TEXT" => $lang['Confirm_delete_style'],

                                "L_YES" => $lang['Yes'],
                                "L_NO" => $lang['No'],

                                "S_CONFIRM_ACTION" => append_sid("admin_styles.$phpEx"),
                                "S_HIDDEN_FIELDS" => $hidden_fields)
                        );

                        $template->pparse("confirm");

                }
                else
                {
                        //
                        // The user has confirmed the delete. Remove the style, the style element
                        // names and update any users who might be using this style
                        //
                        $sql = "DELETE FROM " . THEMES_TABLE . "
                                WHERE themes_id = $style_id";
                        if(!$result = $db->sql_query($sql, BEGIN_TRANSACTION))
                        {
                                message_die(GENERAL_ERROR, "Could not remove style data!", "", __LINE__, __FILE__, $sql);
                        }

                        //
                        // There may not be any theme name data so don't throw an error
                        // if the SQL dosan't work
                        //
                        $sql = "DELETE FROM " . THEMES_NAME_TABLE . "
                                WHERE themes_id = $style_id";
                        $db->sql_query($sql);

                        $sql = "UPDATE " . USERS_TABLE . "
                                SET user_style = " . $board_config['default_style'] . "
                                WHERE user_style = $style_id";
                        if(!$result = $db->sql_query($sql, END_TRANSACTION))
                        {
                                message_die(GENERAL_ERROR, "Could not update user style information", "", __LINE__, __FILE__, $sql);
                        }

                        $message = $lang['Style_removed'] . "<br /><br />" . sprintf($lang['Click_return_styleadmin'], "<a href=\"" . append_sid("admin_styles.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");

                        message_die(GENERAL_MESSAGE, $message);
                }
                break;

        default:

                $sql = "SELECT themes_id, template_name, style_name
                        FROM " . THEMES_TABLE . "
                        ORDER BY template_name";
                if(!$result = $db->sql_query($sql))
                {
                        message_die(GENERAL_ERROR, "Could not get style information!", "", __LINE__, __FILE__, $sql);
                }

                $style_rowset = $db->sql_fetchrowset($result);

                $template->set_filenames(array(
                        "body" => "admin/styles_list_body.tpl")
                );

                $template->assign_vars(array(
                        "L_STYLES_TITLE" => $lang['Styles_admin'],
                        "L_STYLES_TEXT" => $lang['Styles_explain'],
                        "L_STYLE" => $lang['Style'],
                        "L_TEMPLATE" => $lang['Template'],
                        "L_EDIT" => $lang['Edit'],
                        "L_DELETE" => $lang['Delete'])
                );

                for($i = 0; $i < count($style_rowset); $i++)
                {
                        $row_color = ( !($i % 2) ) ? $theme['td_color1'] : $theme['td_color2'];
                        $row_class = ( !($i % 2) ) ? $theme['td_class1'] : $theme['td_class2'];

                        $template->assign_block_vars("styles", array(
                                "ROW_CLASS" => $row_class,
                                "ROW_COLOR" => $row_color,
                                "STYLE_NAME" => $style_rowset[$i]['style_name'],
                                "TEMPLATE_NAME" => $style_rowset[$i]['template_name'],

                                "U_STYLES_EDIT" => append_sid("admin_styles.$phpEx?mode=edit&amp;style_id=" . $style_rowset[$i]['themes_id']),
                                "U_STYLES_DELETE" => append_sid("admin_styles.$phpEx?mode=delete&amp;style_id=" . $style_rowset[$i]['themes_id']))
                        );
                }

                $template->pparse("body");
                break;
}

if (empty($HTTP_POST_VARS['send_file']))
{
        include('./page_footer_admin.'.$phpEx);
}

?>